1100 |
How can I advance to the next line, once the user presses the ENTER key
// KeyDown event - Occurs when the user presses a key while an object has the focus. private void axGrid1_KeyDownEvent(object sender, AxEXGRIDLib._IGridEvents_KeyDownEvent e) { System.Diagnostics.Debug.Print( "KeyCode Before:" ); System.Diagnostics.Debug.Print( e.keyCode.ToString() ); e.keyCode = axGrid1.FormatABC("value = 13 ? 40 : value",e.keyCode,null,null); System.Diagnostics.Debug.Print( "KeyCode After:" ); System.Diagnostics.Debug.Print( e.keyCode.ToString() ); } //this.axGrid1.KeyDownEvent += new AxEXGRIDLib._IGridEvents_KeyDownEventHandler(this.axGrid1_KeyDownEvent); axGrid1.BeginUpdate(); EXGRIDLib.Columns var_Columns = axGrid1.Columns; EXGRIDLib.Editor var_Editor = (var_Columns.Add("A") as EXGRIDLib.Column).Editor; var_Editor.Appearance = EXGRIDLib.InplaceAppearanceEnum.EtchedApp; var_Editor.EditType = EXGRIDLib.EditTypeEnum.EditType; EXGRIDLib.Editor var_Editor1 = (var_Columns.Add("B") as EXGRIDLib.Column).Editor; var_Editor1.Appearance = EXGRIDLib.InplaceAppearanceEnum.EtchedApp; var_Editor1.EditType = EXGRIDLib.EditTypeEnum.EditType; EXGRIDLib.Items var_Items = axGrid1.Items; int h0 = var_Items.AddItem("Item A.1"); var_Items.set_CellValue(h0,1,"Item B.1"); h0 = var_Items.AddItem("Item A.2"); var_Items.set_CellValue(h0,1,"Item B.2"); axGrid1.EndUpdate(); |
1099 |
I am using AddNew to add new records, but I can not see them into the control
// ButtonClick event - Occurs when user clicks on the cell's button. private void axGrid1_ButtonClick(object sender, AxEXGRIDLib._IGridEvents_ButtonClickEvent e) { // Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project. ADODB.Recordset var_Recordset = (axGrid1.DataSource as ADODB.Recordset); var_Recordset.AddNew(null,null); var_Recordset.Fields["A"].Value = "new A"; var_Recordset.Fields["B"].Value = "new B"; var_Recordset.Update(null,null); } //this.axGrid1.ButtonClick += new AxEXGRIDLib._IGridEvents_ButtonClickEventHandler(this.axGrid1_ButtonClick); axGrid1.BeginUpdate(); axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched; ADODB.Recordset rs = new ADODB.Recordset(); rs.Fields.Append("A",ADODB.DataTypeEnum.adBSTR,0,null,null); rs.Fields.Append("B",ADODB.DataTypeEnum.adBSTR,0,null,null); rs.Open(null,null,null,null,0); rs.AddNew(null,null); rs.Fields["A"].Value = "Item A.1"; rs.Fields["B"].Value = "Item B.1"; rs.Update(null,null); rs.AddNew(null,null); rs.Fields["A"].Value = "Item A.2"; rs.Fields["B"].Value = "Item B.2"; rs.Update(null,null); axGrid1.DataSource = (rs as ADODB.Recordset); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1); int h = var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exTop,0); var_Items.set_ItemDivider(h,0); var_Items.set_CellHasButton(h,0,true); var_Items.set_CellValue(h,0,"AddNew"); var_Items.set_CellHAlignment(h,0,EXGRIDLib.AlignmentEnum.CenterAlignment); axGrid1.DetectAddNew = true; axGrid1.DetectDelete = true; axGrid1.EndUpdate(); |
1098 |
How can I create a new ADO recordset
|
1097 |
Do do I get the DAO version I have installed
// Add 'Microsoft DAO 2.5/3.51 Compatibility Library(dao2535.tlb)' reference to your project. System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version ); // Add 'Microsoft DAO 3.6 Object Library(dao360.dll)' reference to your project. System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version ); // Add 'Microsoft Office 15.0 Access database engine Object Library(ACEDAO.DLL)' reference to your project. System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version ); |
1096 |
How do I get a list of interfaces the object implemenets
|
1095 |
Do do I get the ADO version I have installed
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project. System.Diagnostics.Debug.Print( "ADO Version:" ); System.Diagnostics.Debug.Print( new ADODB.Connection().Version ); |
1094 |
DAO, ACCDB, 120
|
1093 |
DAO, MDB, 120
|
1092 |
DAO, MDB
|
1091 |
ADODB, ACCDB, x64
|
1090 |
ADOR, ACCDB
|
1089 |
ADODB, MDB
|
1088 |
ADOR, MDB
|
1087 |
How can I display the row on multiple lines (excrd)
axGrid1.BeginUpdate(); axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched; axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellFormatLevel,"[b=0]60;1[b=15]:60,((20;\"<fgcolor=808080>Dateigröße\"[b=1][a=2]:120,2[b=15])/(20;\"<fgcolor=808080>Erstellt am\"[a=2]:120,3[b=" + "15])/(20;\"<fgcolor=808080>Zuletzt bearbeitet\"[b=4][a=2]:120,4[b=15]))"); var_Column.AllowSort = false; (axGrid1.Columns.Add(1.ToString()) as EXGRIDLib.Column).Visible = false; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add(2.ToString()) as EXGRIDLib.Column); var_Column1.Visible = false; var_Column1.Editor.EditType = EXGRIDLib.EditTypeEnum.EditType; var_Column1.FormatColumn = "1 index `A-Z`"; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add(3.ToString()) as EXGRIDLib.Column); var_Column2.Visible = false; var_Column2.Editor.EditType = EXGRIDLib.EditTypeEnum.EditType; var_Column2.FormatColumn = "1 index ``"; EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add(4.ToString()) as EXGRIDLib.Column); var_Column3.Visible = false; var_Column3.Editor.EditType = EXGRIDLib.EditTypeEnum.EditType; var_Column3.FormatColumn = "date(``)"; axGrid1.DefaultItemHeight = 48; axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines; axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid; axGrid1.set_ViewModeOption(EXGRIDLib.ViewModeEnum.exTableView,EXGRIDLib.ViewModeOptionEnum.exBorderWidth,1); axGrid1.set_ViewModeOption(EXGRIDLib.ViewModeEnum.exTableView,EXGRIDLib.ViewModeOptionEnum.exBorderHeight,1); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem(""),1,"One"); var_Items.set_CellValue(var_Items.AddItem(""),1,"Two"); var_Items.set_CellValue(var_Items.AddItem(""),1,"Three"); axGrid1.EndUpdate(); |
1086 |
Type of wraps the cell's caption support (Sample 2)
axGrid1.BeginUpdate(); axGrid1.HeaderSingleLine = false; axGrid1.HeaderHeight = 36; axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines; axGrid1.ColumnAutoResize = false; axGrid1.ScrollBySingleLine = true; EXGRIDLib.Columns var_Columns = axGrid1.Columns; EXGRIDLib.Column var_Column = (var_Columns.Add("Single-Line (exCaptionSingleLine)") as EXGRIDLib.Column); var_Column.Width = 96; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,-1); EXGRIDLib.Column var_Column1 = (var_Columns.Add("Word-Wrap (exCaptionWordWrap)") as EXGRIDLib.Column); var_Column1.Width = 96; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,0); var_Column1.FormatColumn = "%0"; EXGRIDLib.Column var_Column2 = (var_Columns.Add("Break-Wrap (exCaptionBreakWrap)") as EXGRIDLib.Column); var_Column2.Width = 96; var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,1); var_Column2.FormatColumn = "%0"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line."); var_Items.AddItem("This is the <b>first</b> line.\\r\\nThis is the <b>second</b> line.\\r\\nThis is the <b>third</b> line."); axGrid1.EndUpdate(); |
1085 |
Type of wraps the cell's caption support (Sample 1)
axGrid1.BeginUpdate(); axGrid1.HeaderSingleLine = false; axGrid1.HeaderHeight = 36; axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines; axGrid1.ColumnAutoResize = false; axGrid1.ScrollBySingleLine = true; (axGrid1.Columns.Add("Default") as EXGRIDLib.Column).Width = 128; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line."); var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML); h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap); h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line."); var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML); var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap); h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionBreakWrap); h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line."); var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML); var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionBreakWrap); axGrid1.EndUpdate(); |
1084 |
Can I break the cell's caption using the line break <br> or \r\n (Sample 2)
axGrid1.BeginUpdate(); axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines; axGrid1.ColumnAutoResize = false; axGrid1.ScrollBySingleLine = true; (axGrid1.Columns.Add("Default") as EXGRIDLib.Column).Width = 128; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellSingleLine(var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."),0,EXGRIDLib.CellSingleLineEnum.exCaptionBreakWrap); var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); axGrid1.EndUpdate(); |
1083 |
Can I break the cell's caption using the line break <br> or \r\n (Sample 1)
axGrid1.BeginUpdate(); axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched; axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines; axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesGeometric; axGrid1.ColumnAutoResize = false; axGrid1.ScrollBySingleLine = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column); var_Column.Width = 196; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,1); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("<solidline><b>Bank Account</b></solidline><br>+ owner: String <r><a 1;properties>+</a><br><solidline>+ balance: Currency = 0</s" + "olidline><br>+ deposit(amount: Currency)<r><a ;methods>+</a><br>+ withdraw(amount: Currency)"); var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML); var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); axGrid1.EndUpdate(); |
1082 |
How can I change the visual appearance/color of the Filter For ... field
axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.BackColorHeader = Color.FromArgb(1,0,0); axGrid1.ForeColorHeader = Color.FromArgb(255,255,255); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exBackColorFilter,axGrid1.BackColorHeader); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exForeColorFilter,axGrid1.ForeColorHeader); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240))); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,-1); axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Bump; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Items") as EXGRIDLib.Column); var_Column.FilterOnType = true; var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exNoItems; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); axGrid1.EndUpdate(); |
1081 |
How can I display the cell's caption without spaces on both sides
axGrid1.BeginUpdate(); axGrid1.ColumnAutoResize = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column.FormatColumn = "((trim(value) replace ` ` with ` `) replace ` ` with ` `) replace ` ` with `<bgcolor=FF0000> </bgcolor>`"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(""); var_Items.AddItem("Item A"); var_Items.AddItem(" Item B"); var_Items.AddItem(" Item C "); axGrid1.EndUpdate(); |
1080 |
How can I highlight the spaces within the column (sample 2)
axGrid1.BeginUpdate(); axGrid1.ColumnAutoResize = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column.FormatColumn = "`'` + ( value replace ` ` with `_` ) + `'`"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(""); var_Items.AddItem("Item A"); var_Items.AddItem(" Item B"); var_Items.AddItem(" Item C "); axGrid1.EndUpdate(); |
1079 |
How can I highlight the spaces within the column (sample 1)
axGrid1.BeginUpdate(); axGrid1.ColumnAutoResize = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column.FormatColumn = "len(value) = 0 ? `<bgcolor=FF0000> </bgcolor>` : ( value replace ` ` with `<bgcolor=FF0000> </bgcolor>` )"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(""); var_Items.AddItem("Item A"); var_Items.AddItem(" Item B"); var_Items.AddItem(" Item C "); axGrid1.EndUpdate(); |
1078 |
How can I change the visual aspect of the drop down filter-calendar
axGrid1.BeginUpdate(); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exBackColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,1))); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exForeColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255))); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exDateScrollRange,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255))); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exDateHeader,axGrid1.get_Background(EXGRIDLib.BackgroundPartEnum.exBackColorFilter)); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exDateScrollThumb,(uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128))); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Date") as EXGRIDLib.Column); var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exDate; var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; var_Column.DisplayFilterPattern = false; axGrid1.EndUpdate(); |
1077 |
How can I hide the filter bar description
axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Filter") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column.Filter = "B"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("A"); var_Items.AddItem("B"); var_Items.AddItem("C"); axGrid1.ApplyFilter(); axGrid1.FilterBarHeight = 0; axGrid1.EndUpdate(); |
1076 |
Export Data in HTML format
axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.BackColorAlternate = Color.FromArgb(240,240,240); axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines; axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched; axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " + "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" + "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" + "nt + ` item(s)`) )))"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.FilterBarPromptType = EXGRIDLib.FilterPromptEnum.exFilterPromptContainsAny; EXGRIDLib.ConditionalFormats var_ConditionalFormats = axGrid1.ConditionalFormats; var_ConditionalFormats.Add("%0 like `*parent*`","parent").BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(192,192,192)); EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%0 like `*child*`","child"); var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128)); var_ConditionalFormat.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns; EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%0 like `*B*`","b"); var_ConditionalFormat1.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255)); var_ConditionalFormat1.Bold = true; var_ConditionalFormat1.Italic = true; var_ConditionalFormat1.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns; EXGRIDLib.Columns var_Columns = axGrid1.Columns; EXGRIDLib.Column var_Column = (var_Columns.Add("Value") as EXGRIDLib.Column); var_Column.Width = 128; var_Column.HTMLCaption = "<b>VA</b><r>sko"; EXGRIDLib.Column var_Column1 = (var_Columns.Add("APos") as EXGRIDLib.Column); var_Column1.FormatColumn = "0 apos ``"; var_Column1.AllowSort = false; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,15790320); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor)); var_Column1.Position = 0; EXGRIDLib.Column var_Column2 = (var_Columns.Add("RPos") as EXGRIDLib.Column); var_Column2.FormatColumn = "0 rpos ``"; var_Column2.AllowSort = false; var_Column2.Position = 1; EXGRIDLib.Column var_Column3 = (var_Columns.Add("Index") as EXGRIDLib.Column); var_Column3.FormatColumn = "0 index ``"; var_Column3.DisplayFilterButton = true; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowCheckBox; var_Column3.Position = 2; EXGRIDLib.Column var_Column4 = (var_Columns.Add("Data 1") as EXGRIDLib.Column); var_Column4.FormatColumn = "0 index `A-Z`"; var_Column4.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); EXGRIDLib.Column var_Column5 = (var_Columns.Add("Data 2") as EXGRIDLib.Column); var_Column5.FormatColumn = "0 index `AB` replace `A` with `<off -4>A</off>`"; var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,false); var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellHasRadioButton,true); EXGRIDLib.Column var_Column6 = (var_Columns.Add("Data 3") as EXGRIDLib.Column); var_Column6.FormatColumn = "0 index `CDC` replace `D` with `<b>D</b>`"; var_Column6.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("ParentA"); var_Items.InsertItem(h,null,"Child A"); var_Items.InsertItem(h,null,"Child B"); var_Items.set_CellState(h,4,1); var_Items.set_CellBackColor(var_Items.InsertItem(h,null,"Child C"),5,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0))); var_Items.set_ExpandItem(h,true); var_Items.AddItem("Item A"); h = var_Items.AddItem("ParentB"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_CellBackColor(var_Items.InsertItem(h,null,"Child 3"),5,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0))); var_Items.set_CellState(h,5,1); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); var_Items.AddItem("Item D"); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); string sFile = "c:/temp/export.html"; axGrid1.Export(sFile,"vis"); // Add 'Microsoft Internet Controls(ieframe.dll)' reference to your project. SHDocVw.ShellBrowserWindow var_ShellBrowserWindow = new SHDocVw.ShellBrowserWindow(); var_ShellBrowserWindow.Navigate2(sFile,null,null,null,null); |
1075 |
Export Data in CSV format
axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.BackColorAlternate = Color.FromArgb(240,240,240); axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines; axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched; axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " + "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" + "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" + "nt + ` item(s)`) )))"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.FilterBarPromptType = EXGRIDLib.FilterPromptEnum.exFilterPromptContainsAny; EXGRIDLib.ConditionalFormats var_ConditionalFormats = axGrid1.ConditionalFormats; var_ConditionalFormats.Add("%0 like `*parent*`","parent").BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(192,192,192)); EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%0 like `*child*`","child"); var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128)); var_ConditionalFormat.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns; EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%0 like `*B*`","b"); var_ConditionalFormat1.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255)); var_ConditionalFormat1.Bold = true; var_ConditionalFormat1.Italic = true; var_ConditionalFormat1.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns; EXGRIDLib.Columns var_Columns = axGrid1.Columns; EXGRIDLib.Column var_Column = (var_Columns.Add("Value") as EXGRIDLib.Column); var_Column.Width = 128; var_Column.HTMLCaption = "<b>VA</b><r>sko"; EXGRIDLib.Column var_Column1 = (var_Columns.Add("APos") as EXGRIDLib.Column); var_Column1.FormatColumn = "0 apos ``"; var_Column1.AllowSort = false; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,15790320); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor)); var_Column1.Position = 0; EXGRIDLib.Column var_Column2 = (var_Columns.Add("RPos") as EXGRIDLib.Column); var_Column2.FormatColumn = "0 rpos ``"; var_Column2.AllowSort = false; var_Column2.Position = 1; EXGRIDLib.Column var_Column3 = (var_Columns.Add("Index") as EXGRIDLib.Column); var_Column3.FormatColumn = "0 index ``"; var_Column3.DisplayFilterButton = true; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowCheckBox; var_Column3.Position = 2; EXGRIDLib.Column var_Column4 = (var_Columns.Add("Data 1") as EXGRIDLib.Column); var_Column4.FormatColumn = "0 index `A-Z`"; var_Column4.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); EXGRIDLib.Column var_Column5 = (var_Columns.Add("Data 2") as EXGRIDLib.Column); var_Column5.FormatColumn = "0 index `AB` replace `A` with `<off -4>A</off>`"; var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,false); var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellHasRadioButton,true); EXGRIDLib.Column var_Column6 = (var_Columns.Add("Data 3") as EXGRIDLib.Column); var_Column6.FormatColumn = "0 index `CDC` replace `D` with `<b>D</b>`"; var_Column6.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("ParentA"); var_Items.InsertItem(h,null,"Child A"); var_Items.InsertItem(h,null,"Child B"); var_Items.set_CellState(h,4,1); var_Items.set_CellBackColor(var_Items.InsertItem(h,null,"Child C"),5,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0))); var_Items.set_ExpandItem(h,true); var_Items.AddItem("Item A"); h = var_Items.AddItem("ParentB"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_CellBackColor(var_Items.InsertItem(h,null,"Child 3"),5,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0))); var_Items.set_CellState(h,5,1); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); var_Items.AddItem("Item D"); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); System.Diagnostics.Debug.Print( axGrid1.Export("","vis").ToString() ); |
1074 |
Is it possible to check multiple-items at once
// AddItem event - Occurs after a new Item has been inserted to Items collection. private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e) { object bHasParent = axGrid1.FormatABC("value != 0",axGrid1.Items.get_ItemParent(e.item),null,null); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellHasCheckBox(e.item,0,false); } //this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column.FormatColumn = "value + (%CS0 = 1 ? `<r><fgcolor=808080>(checked)` : ``)"; axGrid1.HeaderVisible = true; axGrid1.SingleSel = false; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Project"); int hChild = var_Items.InsertItem(h,null,"Task 1"); hChild = var_Items.InsertItem(h,null,"Task 2"); hChild = var_Items.InsertItem(h,null,"Task 3"); var_Items.set_ExpandItem(h,true); var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1); var_Items.set_CellValue(var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exTop,0),0,"<c>Select multiple items and press the <b>SPACE</b> key"); axGrid1.EndUpdate(); |
1073 |
How can I get the icon from the cell when using the Items.CellImages property (icon index)
// MouseMove event - Occurs when the user moves the mouse. private void axGrid1_MouseMoveEvent(object sender, AxEXGRIDLib._IGridEvents_MouseMoveEvent e) { int i = axGrid1.get_ItemFromPoint(-1,-1,c,hit); System.Diagnostics.Debug.Print( axGrid1.FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? ( ( (value bitand 0xFFFF0000) bitshift 16 ) array B split `,` ) : `no image`",hit,axGrid1.Items.get_CellImages(i,c),null).ToString() ); } //this.axGrid1.MouseMoveEvent += new AxEXGRIDLib._IGridEvents_MouseMoveEventHandler(this.axGrid1_MouseMoveEvent); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); axGrid1.Columns.Add("Default"); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellImages(var_Items.AddItem("Item 1"),0,"3,2,1"); var_Items.set_CellImages(var_Items.AddItem("Item 2"),0,"2,3"); var_Items.set_CellImages(var_Items.AddItem("Item 3"),0,"2,"); axGrid1.EndUpdate(); |
1072 |
How can I get the icon from the cell when using the Items.CellImages property (icon position within the cell)
// MouseMove event - Occurs when the user moves the mouse. private void axGrid1_MouseMoveEvent(object sender, AxEXGRIDLib._IGridEvents_MouseMoveEvent e) { int i = axGrid1.get_ItemFromPoint(-1,-1,c,hit); System.Diagnostics.Debug.Print( axGrid1.FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? 1 + ( (value bitand 0xFFFF0000) bitshift 16 ) : `no image`",hit,null,null).ToString() ); } //this.axGrid1.MouseMoveEvent += new AxEXGRIDLib._IGridEvents_MouseMoveEventHandler(this.axGrid1_MouseMoveEvent); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); axGrid1.Columns.Add("Default"); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellImages(var_Items.AddItem("Item 1"),0,"3,2,1"); var_Items.set_CellImages(var_Items.AddItem("Item 2"),0,"2,3"); var_Items.set_CellImages(var_Items.AddItem("Item 3"),0,"2"); axGrid1.EndUpdate(); |
1071 |
Is it possible to change the visual appearance of the position signs when user changes the column's position by drag and drop
axGrid1.BeginUpdate(); axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched; EXGRIDLib.Columns var_Columns = axGrid1.Columns; var_Columns.Add("Column 1"); var_Columns.Add("Column 2"); var_Columns.Add("Column 3"); EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" + "IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" + "aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" + "eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDI" + "BICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAok" + "GKHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI="); var_Appearance.Add(2,"CP:1 0 -36 0 0"); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exColumnsPositionSign,0x2000000); axGrid1.EndUpdate(); |
1070 |
How can I add a title column
axGrid1.BeginUpdate(); axGrid1.HeaderHeight = 22; axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched; axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines; EXGRIDLib.Columns var_Columns = axGrid1.Columns; var_Columns.Add("Col 1"); (var_Columns.Add("Col 2") as EXGRIDLib.Column).FormatColumn = "1 pos ``"; (var_Columns.Add("Col 3") as EXGRIDLib.Column).FormatColumn = "1 pos `A-`"; (var_Columns.Add("Col 4") as EXGRIDLib.Column).FormatColumn = "1 pos `A-Z`"; EXGRIDLib.Column var_Column = (var_Columns.Add("Title") as EXGRIDLib.Column); var_Column.ExpandColumns = "0,1,2,3"; var_Column.DisplayExpandButton = false; var_Column.AllowSort = false; var_Column.AllowDragging = false; var_Column.Position = 0; var_Column.HeaderAlignment = EXGRIDLib.AlignmentEnum.CenterAlignment; axGrid1.ColumnAutoResize = false; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item 1"); var_Items.AddItem("Item 2"); var_Items.AddItem("Item 3"); var_Items.AddItem("Item 4"); axGrid1.EndUpdate(); System.Diagnostics.Debug.Print( axGrid1.Export("",null).ToString() ); |
1069 |
FilterBarCaption ALLUI Keyword ( sample 3, result, leaf )
// AddGroupItem event - Occurs after a new Group Item has been inserted to Items collection. private void axGrid1_AddGroupItem(object sender, AxEXGRIDLib._IGridEvents_AddGroupItemEvent e) { EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_ItemBackColor(e.item,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240))); object val = var_Items.get_CellValue(e.item,var_Items.get_GroupItem(e.item)); var_Items.set_CellState(e.item,var_Items.get_GroupItem(e.item),axGrid1.FormatABC("A = `Checked` ? 1 : 0",val,null,null)); } //this.axGrid1.AddGroupItem += new AxEXGRIDLib._IGridEvents_AddGroupItemEventHandler(this.axGrid1_AddGroupItem); // AddItem event - Occurs after a new Item has been inserted to Items collection. private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e) { object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null); axGrid1.Items.set_CellImage(e.item,3,i); } //this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck; EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox; EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 rpos ``"; var_Column4.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); int h = var_Items.AddItem("Item B"); var_Items.set_CellValue(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " + "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" + "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + leafitemcount + ` result(s)` ) : (`<r><fgcolor=808080>`+ leafitemcount + `" + " item(s)`) )))"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.AllowGroupBy = true; axGrid1.SortBarVisible = true; EXGRIDLib.Column var_Column5 = axGrid1.Columns[2]; var_Column5.FormatColumn = "%CS2 ? `Checked` : `Unchecked`"; var_Column5.SortOrder = EXGRIDLib.SortOrderEnum.SortAscending; axGrid1.EndUpdate(); |
1068 |
A black portion is shown while I am using the BackColorAlternate with EBN colors. What can I do
axGrid1.BeginUpdate(); axGrid1.ColumnAutoResize = true; axGrid1.DefaultItemHeight = 20; axGrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhIDhAxHAxg0HG0Mg4xGI3HMOig3GcJiYAf8jAEhhUnAAyhEqg8hk0oAsIjgAiAwmYxGA4mYzGwwkI0i0ooUnB0IBMIl1Dg8zmYyGolptPkI1m" + "Y1GAll9KoUslNIrVCqNQldShFUstXAVfrVcrlZtVhuFnsUHq1zoczoQGhFBkNpg6zbDykUkhsPHE2h85nc9n8xtVDtlex9Msd2p1YstVq9ux8HyMtzuFz1PsNTzQlv2h" + "hWfkuqpeVuN0q+nvEooN5veSAGpkb/ACcZrvhU3w83nM/poxGuchGpoVBvWgg+8knA4WimnFxI45Er5XOlHMg/Q3XU33W4ew9Wyu11mchDagcO7zus8VDoNBBEIKBpMY" + "6DqOQyokhA/IQIQmwMk4bIQFDcoO6LWgwhQkNcABwEyAB5GwWbet6cRQg3DENQ5D8QxADZvEkAB8nabsURGeBpFM3pwE2AEZRpDx/neZpOR3Dz9oO/r/wCMoZNTBQAQR" + "JSEwYg8HPGhEIoNCaEwq10gQ2WcRt7LcRxRFpuxUAEURQ3sczBEMgTTG8gN7HpOSEAEiQBAQZpmQ0DibPUFwbKcHwkhQoQtNQNzNEMbABOKDy/DMYQzHLeoPL0OTJSUd" + "0pHcxTewk5zrIygIRPslz4lEngBKIAQivgASs/kLSBTlO00f8t0vGcgUbDlDRjXLCUNRERRvRgAHW2oAICA=="); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Position") as EXGRIDLib.Column); var_Column1.FormatColumn = "1 rindex ``"; var_Column1.Visible = false; EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%C1 mod 2",null); var_ConditionalFormat.BackColor = 0x1000000; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item 1"); var_Items.AddItem("Item 2"); var_Items.AddItem("Item 3"); var_Items.AddItem("Item 4"); axGrid1.EndUpdate(); |
1067 |
How can I specify alternate background colors for each root item, similar with BackColorAlternate
axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Position") as EXGRIDLib.Column); var_Column1.FormatColumn = "( ( 1:=( ( 0:=(1 rpos '') ) lfind `.`) ) < 0 ? =:0 : (=:0 left =:1) )"; var_Column1.Visible = false; EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%C1 mod 2",null); var_ConditionalFormat.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); h = var_Items.AddItem("Root 3"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); axGrid1.EndUpdate(); |
1066 |
Is it possible to change the caption from a column without to remove the column and add it with the new caption
(axGrid1.Columns.Add("ColumnName") as EXGRIDLib.Column).Caption = "NewName"; (axGrid1.Columns.Add("ColumnName") as EXGRIDLib.Column).HTMLCaption = "<b>New</b>Name"; |
1065 |
FilterBarCaption ALL Keyword ( sample 2, result )
// AddItem event - Occurs after a new Item has been inserted to Items collection. private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e) { object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null); axGrid1.Items.set_CellImage(e.item,3,i); } //this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); EXGRIDLib.Editor var_Editor = var_Column2.Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType; var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck; EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox; EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); int h = var_Items.AddItem("Item B"); var_Items.set_CellValue(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "(( ( all replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `[" + "<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matchi" + "temcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount" + " + ` item(s)`) )))"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column5 = axGrid1.Columns[0]; var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A|Item B"; axGrid1.Columns[2].Filter = 1.ToString(); axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1064 |
FilterBarCaption ALL Keyword ( sample 1 )
// AddItem event - Occurs after a new Item has been inserted to Items collection. private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e) { object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null); axGrid1.Items.set_CellImage(e.item,3,i); } //this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); EXGRIDLib.Editor var_Editor = var_Column2.Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType; var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck; EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox; EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); int h = var_Items.AddItem("Item B"); var_Items.set_CellValue(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "all"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column5 = axGrid1.Columns[0]; var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A|Item B"; axGrid1.Columns[2].Filter = 1.ToString(); axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1063 |
FilterBarCaption ALLUI Keyword ( sample 2, result )
// AddItem event - Occurs after a new Item has been inserted to Items collection. private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e) { object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null); axGrid1.Items.set_CellImage(e.item,3,i); } //this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); EXGRIDLib.Editor var_Editor = var_Column2.Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType; var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck; EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox; EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); int h = var_Items.AddItem("Item B"); var_Items.set_CellValue(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " + "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" + "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" + "nt + ` item(s)`) )))"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column5 = axGrid1.Columns[0]; var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A|Item B"; axGrid1.Columns[2].Filter = 1.ToString(); axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1062 |
FilterBarCaption ALLUI Keyword ( sample 1 )
// AddItem event - Occurs after a new Item has been inserted to Items collection. private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e) { object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null); axGrid1.Items.set_CellImage(e.item,3,i); } //this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); EXGRIDLib.Editor var_Editor = var_Column2.Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType; var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck; EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox; EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); int h = var_Items.AddItem("Item B"); var_Items.set_CellValue(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "allui"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column5 = axGrid1.Columns[0]; var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A|Item B"; axGrid1.Columns[2].Filter = 1.ToString(); axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1061 |
FilterBarCaption AVAILABLE Keyword ( sample 2, result )
// AddItem event - Occurs after a new Item has been inserted to Items collection. private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e) { object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null); axGrid1.Items.set_CellImage(e.item,3,i); } //this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); EXGRIDLib.Editor var_Editor = var_Column2.Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType; var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck; EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox; EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); int h = var_Items.AddItem("Item B"); var_Items.set_CellValue(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "(( ( value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` ) + ` ` + ( ava" + "ilable replace `[` with `<bgcolor=C0C0C0><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` replace `<s>` with `" + "` replace `</s>` with `` ) + `<fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount" + " + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount + ` item(s)`) )))"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column5 = axGrid1.Columns[0]; var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A|Item B"; axGrid1.Columns[2].Filter = 1.ToString(); axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1060 |
FilterBarCaption AVAILABLE Keyword ( sample 1 )
// AddItem event - Occurs after a new Item has been inserted to Items collection. private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e) { object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null); axGrid1.Items.set_CellImage(e.item,3,i); } //this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem); axGrid1.BeginUpdate(); axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); EXGRIDLib.Editor var_Editor = var_Column2.Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType; var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck; EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox; EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); int h = var_Items.AddItem("Item B"); var_Items.set_CellValue(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "value + ` ` + available"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column5 = axGrid1.Columns[0]; var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A|Item B"; axGrid1.Columns[2].Filter = 1.ToString(); axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1059 |
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 3, results )
axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column2.AllowSizing = false; var_Column2.AllowSort = false; var_Column2.Width = 32; var_Column2.FormatColumn = "1 apos ``"; var_Column2.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); var_Items.set_CellValue(var_Items.AddItem("Item B"),1,"Sub-Item B"); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "(`<b>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) +" + " ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )) replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replac" + "e `]` with ` </b></bgcolor></fgcolor>`"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle; EXGRIDLib.Column var_Column3 = axGrid1.Columns[0]; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column3.Filter = "Item A|Item B"; EXGRIDLib.Column var_Column4 = axGrid1.Columns[1]; var_Column4.FilterType = EXGRIDLib.FilterTypeEnum.exPattern; var_Column4.Filter = "*B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1058 |
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 2 )
axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column2.AllowSizing = false; var_Column2.AllowSort = false; var_Column2.Width = 32; var_Column2.FormatColumn = "1 apos ``"; var_Column2.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); var_Items.set_CellValue(var_Items.AddItem("Item B"),1,"Sub-Item B"); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>`"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle; EXGRIDLib.Column var_Column3 = axGrid1.Columns[0]; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column3.Filter = "Item A|Item B"; EXGRIDLib.Column var_Column4 = axGrid1.Columns[1]; var_Column4.FilterType = EXGRIDLib.FilterTypeEnum.exPattern; var_Column4.Filter = "*B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1057 |
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 1 )
axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column2.AllowSizing = false; var_Column2.AllowSort = false; var_Column2.Width = 32; var_Column2.FormatColumn = "1 apos ``"; var_Column2.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A"); var_Items.set_CellValue(var_Items.AddItem("Item B"),1,"Sub-Item B"); var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C"); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axGrid1.FilterBarCaption = "value replace `[` with `<fgcolor=808080>[` replace `]` with `]</fgcolor>`"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle; EXGRIDLib.Column var_Column3 = axGrid1.Columns[0]; var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column3.Filter = "Item A|Item B"; EXGRIDLib.Column var_Column4 = axGrid1.Columns[1]; var_Column4.FilterType = EXGRIDLib.FilterTypeEnum.exPattern; var_Column4.Filter = "*B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1056 |
Is it possible to automatically displays the control's filter label to the right
axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Item") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column1.AllowSizing = false; var_Column1.AllowSort = false; var_Column1.Width = 32; var_Column1.FormatColumn = "1 apos ``"; var_Column1.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarCaption = "`<r>` + value"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight | EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle; EXGRIDLib.Column var_Column2 = axGrid1.Columns[0]; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column2.Filter = "Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1055 |
How can I get the number of results/items being shown in the control's filter bar (sample 4)
axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Item") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column1.AllowSizing = false; var_Column1.AllowSort = false; var_Column1.Width = 32; var_Column1.FormatColumn = "1 apos ``"; var_Column1.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.FilterBarPrompt = axGrid1.FormatABC("`<b>` + value",axGrid1.FilterBarPrompt,null,null).ToString(); axGrid1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " + "+ 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight | EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.EndUpdate(); |
1054 |
How can I get the number of results being shown in the control's filter bar (sample 3)
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " + "+ 1) + ` result(s)` ) : ``)"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A|Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1053 |
How can I get the number of results being shown in the control's filter bar (sample 2, compact)
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A|Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1052 |
How can I get the number of results being shown in the control's filter bar (sample 1)
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.FilterBarCaption = "`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A|Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1051 |
FilterBarCaption Predefined Keywords
// AfterExpandItem event - Fired after an item is expanded (collapsed). private void axGrid1_AfterExpandItem(object sender, AxEXGRIDLib._IGridEvents_AfterExpandItemEvent e) { axGrid1.Refresh(); } //this.axGrid1.AfterExpandItem += new AxEXGRIDLib._IGridEvents_AfterExpandItemEventHandler(this.axGrid1_AfterExpandItem); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); EXGRIDLib.Editor var_Editor = var_Column.Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType; var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false; var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exCheck; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column1.AllowSizing = false; var_Column1.AllowSort = false; var_Column1.Width = 32; var_Column1.FormatColumn = "1 apos ``"; var_Column1.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); int h = var_Items.AddItem("Item B"); var_Items.set_CellState(var_Items.InsertItem(h,null,"Sub-Item B1"),1,1); var_Items.InsertItem(h,null,"Sub-Item B2"); var_Items.set_ExpandItem(h,true); var_Items.AddItem("Item C"); axGrid1.FilterInclude = EXGRIDLib.FilterIncludeEnum.exItemsWithChilds; axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.FilterBarCaption = "`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</" + "i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" + ": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" + "<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" + "i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" + "08080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount +" + " `</fgcolor>`"; axGrid1.FilterBarPromptPattern = "B"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column2 = axGrid1.Columns[0]; var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column2.Filter = "Item A|Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1050 |
I am using filter prompt feature, and also column's filter, just wondering if possible to compact displaying the filter bar so it won't show on multiple lines
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp); axGrid1.FilterBarCaption = "`<r><i><fgcolor=808080><upline><solidline><sha ;;0>` + value"; axGrid1.FilterBarPromptPattern = "B"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A|Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1049 |
Just wondering if it is possible to show the filter bar's close button on the right ( sample 2 )
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight | EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.FilterBarPrompt = axGrid1.FormatABC("`<r>` + value",axGrid1.FilterBarPrompt,null,null).ToString(); axGrid1.EndUpdate(); |
1048 |
Just wondering if it is possible to show the filter bar's close button on the right ( sample 1 )
axGrid1.BeginUpdate(); axGrid1.RightToLeft = true; (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.EndUpdate(); |
1047 |
How can I change the visual appearance of the filter bar's close button (EBN)
axGrid1.BeginUpdate(); EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ" + "jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" + "SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" + "OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" + "DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" + "AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" + "JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" + "0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" + "kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" + "MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" + "QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ"); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exFooterFilterBarButton,0x1000000); axGrid1.EndUpdate(); |
1046 |
How can I change the visual appearance of the filter bar's close button (solid)
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exFooterFilterBarButton,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0))); axGrid1.EndUpdate(); |
1045 |
Is it possible to prevent definitely showing the filter bar's close button
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exFooterFilterBarButton,-1); axGrid1.EndUpdate(); |
1044 |
Is it possible to show the close button only if there is a filter applied
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.EndUpdate(); |
1043 |
The control's filter bar is not closed once I click the close button (toggle)
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exBottom,1); int h = var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exBottom,0); var_Items.set_ItemDivider(h,0); var_Items.set_CellValue(h,0,"<c><fgcolor=808080>Press the CTRL + F to turn on/off the control's filter bar. ALT + Up/Down moves the focus."); var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML); axGrid1.FilterBarCaption = "`<r><fgcolor=808080>` + value"; axGrid1.FilterBarPromptPattern = "B"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1042 |
How can I display the control's filter on a single line
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarCaption = "len(value) ? `filter for: <fgcolor 808080>` + value : `<fgcolor 808080>no filter`"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A|Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1041 |
How can I display the control's filter on a single line (prompt-combined)
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarCaption = "`<r>` + value"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A|Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1040 |
How can I get the number of results after a filter is applied
// Click event - Occurs when the user presses and then releases the left mouse button over the grid control. private void axGrid1_ClickEvent(object sender, EventArgs e) { axGrid1.ClearFilter(); } //this.axGrid1.ClickEvent += new EventHandler(this.axGrid1_ClickEvent); // FilterChange event - Occurs when filter was changed. private void axGrid1_FilterChange(object sender, EventArgs e) { System.Diagnostics.Debug.Print( "Items.MatchItemCount" ); System.Diagnostics.Debug.Print( axGrid1.Items.MatchItemCount.ToString() ); System.Diagnostics.Debug.Print( axGrid1.FormatABC("value < 0 ? `filter applied: ` + abs(value + 1) + ` result(s)` : `no filter`",axGrid1.Items.MatchItemCount,null,null).ToString() ); } //this.axGrid1.FilterChange += new EventHandler(this.axGrid1_FilterChange); axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.FilterBarPromptPattern = "Item"; axGrid1.EndUpdate(); |
1039 |
How can I programmatically clear the control's filter
// Click event - Occurs when the user presses and then releases the left mouse button over the grid control. private void axGrid1_ClickEvent(object sender, EventArgs e) { axGrid1.ClearFilter(); } //this.axGrid1.ClickEvent += new EventHandler(this.axGrid1_ClickEvent); axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.FilterBarPromptPattern = "B"; axGrid1.EndUpdate(); |
1038 |
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptPattern = "B"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1037 |
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axGrid1.FilterBarPromptPattern = "B"; axGrid1.EndUpdate(); |
1036 |
Is it possible to prevent closing the control's filter bar, so it is always shown
axGrid1.BeginUpdate(); (axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item A"); var_Items.AddItem("Item B"); var_Items.AddItem("Item C"); axGrid1.FilterBarCaption = "len(value) = 0 ? `<fgcolor=808080>no filter` : value"; axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible; EXGRIDLib.Column var_Column1 = axGrid1.Columns[0]; var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item B"; axGrid1.ApplyFilter(); axGrid1.EndUpdate(); |
1035 |
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 4)
axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.VisualDesign = "gBFLBWIgBAEHhEJAEGg6VAkHeLpgwChAOhULB8XAUUg8MAAREEHGMcgRCJ0ei8dhABDEcQAAYAQGKIYBkAKBQAGaAoDDMOQwQwAAxjGKEEwsACEIrjKCRShyCYZRhGc" + "TSBCIZBqEqSZLiEZRQiiCYsS5GQBRWAkEwiBiEQTjea5CgOIAFS7LIqjRQEBxhIaZYIGaiQADENo9TxIMZAfBIHShK6NJABCCSQKkYx0HScRijDIEFwGIQmbKiej4DCi" + "CQQW7OYYRVCNMQSfa8HivJyrcamfp/YBgOBYHb1eLVPR5LwfPCGUw1P6PLxkORZHimK4tSLHV7xVpMIwZFafIQhCCoHomS5NU7UNR0TQUFx9FaGX7rDDsGwLAJ6XRgF4" + "bg2VpnHePpenAN4bH2GwHFmApSjEGBLnWOpRGOTBZHOegrE6BxPiWVJqCweQrn0LgJAWJBjwgaw1gKO5HmWch5h+fovF+G5bmich4BgfZkB8dynRUVYqiUR5rnmex/F6" + "N4tn2AJfnebZ3DEXw3HWXgzAyIwgicKJKBKEIhCeCgiHyHYFEmSAFmqBghFIdgSCeIJygYDAyAgJx6AoIINAMOJNCgCZCGoGoLmMCI+CwJoihMNglCCIhzFCUg0EmMhg" + "hWDBkAiQg9CUY4jEYN4Jk2IxklYJoJHIUg+CSZJSESFwkkkGI+FOFIJEIRhPhMCRJCSVoRrSBhiDgTZjHYT4PEkYhwhgJYm0SaIaiaSYuE+GQNlmCIBGCJxjhiZQ5AkM" + "hAg6ExJCkPhPguaAiFYUAlAkKZ0g6HoOEmWR/GHcA4m0OwIlIJIHCRgQshGJhpjoaocieaZiC6GAimkUgehIOwnGYGYIGkah6jaE4rg6SpCjKK5rEOMYlGIGIihKOggl" + "oFoqj6L5aGaBo6CkGIkAQjiPpCAAaJILCTJQlKPACDaXJgmSaJsnCdJ4nygKEoijKQpSmKcqCpKoqysK0rivLAsSyLMtC1LYty4Lkui7LwvS+L8wDBMIwzEMUxjHMgyT" + "KMszDNM4zzQNE0jTNQ1TWNc2DZNo2zcN03jfOA4TiOM5DlOY5zoOk6jrOw7TuO88DxPI8z0PU9j3Pg+T6Ps/D9P4/0AQFAkDQRBUGQdCEJQpC0MQ1DkPRBEUSRNFEVBh" + "FkXRhGQ9D6Dxfh+W5gGGd4QH2XQjCmDpFFaKoVB+D5Xmed5+H8YAHnIAh9EwV5Fl0d4MkMKJICmSgygSJAoEmMUCIPgnDCCIOQFYCxJjwFoCcA4kxoF+AIJkAgExegDE" + "gEYQInAzCUAIOEGgfxiiRDYF1Q4EQ2BSCaEQYwbAiKREMpRSymFNDIAkAxT6oVRgSA2qdVKq1WqvVirMZQUhSCnBUMoIgoQRgnGSIQUgkg1hIHYAkAYMROAmHiLsE4xx" + "SCxBwEwCQ0wmDdBsE0GYXBtg2CSPMFIuwYiQBYBQeAcwOCnBCCZgw0g0glBONAQgqQThCGgPQGoBQfiRGmOEZIPAXjsBoPAO4HRThhA0EQSA5BAgaCKJIGg3QdhOCmNU" + "BoQAijTCIF0FwQxpCHDIPAYYMQGgtCmFcaQtRAjZCyFYSojQ2B2BoKwIYFApBXEIBsIQ1QsAWAWEwaA1xCgjAoIAQBAQ="; axGrid1.Columns.Add("Column"); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,null,"Child"); axGrid1.EndUpdate(); |
1034 |
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 3)
axGrid1.BeginUpdate(); EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(3,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" + "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" + "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" + "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" + "XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" + "gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" + "INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA="); var_Appearance.Add(1,"CP:3 -2 -2 2 2"); var_Appearance.Add(4,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" + "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" + "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" + "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" + "eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" + "FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" + "JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI="); var_Appearance.Add(2,"CP:4 -2 -2 2 2"); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesAtRoot; axGrid1.HasButtons = EXGRIDLib.ExpandButtonEnum.exCustom; axGrid1.set_HasButtonsCustom(false,16777216); axGrid1.set_HasButtonsCustom(true,33554432); axGrid1.Columns.Add("Column"); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,null,"Child"); axGrid1.EndUpdate(); |
1033 |
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 2)
axGrid1.BeginUpdate(); EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(1,"XP:TREEVIEW 2 1"); var_Appearance.Add(2,"XP:TREEVIEW 2 2"); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exTreeGlyphOpen,0x1000000); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exTreeGlyphClose,0x2000000); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.Columns.Add("Column"); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,null,"Child"); axGrid1.EndUpdate(); |
1032 |
How can I find if the control is running in DPI mode
System.Diagnostics.Debug.Print( axGrid1.FormatABC("dpi = 1 ? `normal/stretch mode` : `dpi mode`",null,null,null).ToString() ); |
1031 |
How can I change the visual appearance of the +/- buttons (method 1)
axGrid1.BeginUpdate(); EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" + "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" + "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" + "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" + "XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" + "gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" + "INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA="); var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" + "BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" + "DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" + "llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" + "eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" + "FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" + "JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI="); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exTreeGlyphOpen,0x1000000); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exTreeGlyphClose,0x2000000); axGrid1.Columns.Add("Column"); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,null,"Child"); axGrid1.EndUpdate(); |
1030 |
I am using single selection, the question is if possible to select an item only when the user releases the mouse, as currently it selects the item as soon as the user clicks it
// SelectionChanged event - Fired after a new item has been selected. private void axGrid1_SelectionChanged(object sender, EventArgs e) { System.Diagnostics.Debug.Print( "SelectionChanged" ); } //this.axGrid1.SelectionChanged += new EventHandler(this.axGrid1_SelectionChanged); axGrid1.BeginUpdate(); axGrid1.FreezeEvents(true); axGrid1.SingleSel = true; axGrid1.SelectOnRelease = true; (axGrid1.Columns.Add("Column") as EXGRIDLib.Column).FormatColumn = "1 apos `A-Z`"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(""); var_Items.set_SelectItem(var_Items.AddItem(""),true); var_Items.AddItem(""); axGrid1.FreezeEvents(false); axGrid1.EndUpdate(); |
1029 |
Is it possible to select nothing
// SelectionChanged event - Fired after a new item has been selected. private void axGrid1_SelectionChanged(object sender, EventArgs e) { System.Diagnostics.Debug.Print( "SelectionChanged" ); } //this.axGrid1.SelectionChanged += new EventHandler(this.axGrid1_SelectionChanged); axGrid1.BeginUpdate(); axGrid1.FreezeEvents(true); axGrid1.AllowSelectNothing = true; (axGrid1.Columns.Add("Column") as EXGRIDLib.Column).FormatColumn = "1 apos `A-Z`"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(""); var_Items.set_SelectItem(var_Items.AddItem(""),true); var_Items.AddItem(""); axGrid1.FreezeEvents(false); axGrid1.EndUpdate(); |
1028 |
How can I specify the color for control's selection when it loses the focus
axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.AllowDragging = false; var_Column.AllowSort = false; var_Column.Width = 24; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasButton,true); (axGrid1.Columns.Add("Column") as EXGRIDLib.Column).FormatColumn = "1 apos `A-Z`"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(""); var_Items.set_SelectItem(var_Items.AddItem(""),true); var_Items.AddItem(""); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exSelBackColorHide,(uint)ColorTranslator.ToWin32(Color.FromArgb(196,196,196))); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exSelForeColorHide,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,1))); axGrid1.EndUpdate(); |
1027 |
How can I change the background color for checked items (EBN color, frame)
// CellStateChanged event - Fired after cell's state has been changed. private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e) { axGrid1.Refresh(); } //this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent; axGrid1.DefaultItemHeight = 22; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABUkIQAAYAQGKIcBiAKBQAGYBIJDEMQ3DjAUBjMK4ZwTC4AIQjCK4JDKHYJRpHEZgLBMJAAGIZYhhUYRUiYMkiJBGGDIDiGGI2SJAcbTVIEc" + "x9EyUJSgSTJOjCMokTTIU4TTLYASbJafJJhWSaAiyMouDIOMg1BDNIw/Hika6jOgKUisNJXRzWIBTbDlOQ3JqnbCjOQRSrQBoNDAMAiiaKlbwJPK9RoieQXfwUAJrXJc" + "FqXFSLVxNBKAQEBA="); var_Appearance.Add(1,"CP:2 1 1 -1 -1"); EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null); var_ConditionalFormat.BackColor = 0x1000000; axGrid1.HeaderVisible = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Project"); int hChild = var_Items.InsertItem(h,null,"Task 1"); var_Items.set_SelectItem(hChild,true); hChild = var_Items.InsertItem(h,null,"Task 2"); var_Items.set_CellState(hChild,0,1); hChild = var_Items.InsertItem(h,null,"Task 3"); var_Items.set_CellState(hChild,0,1); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1026 |
How can I change the caption of the checked items (sample 2)
axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column.FormatColumn = "%CS0 = 1 ? `<bgcolor=000000><fgcolor=FFFFFF> ` + value + ` </fgcolor></bgcolor>` : value"; axGrid1.HeaderVisible = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Project"); int hChild = var_Items.InsertItem(h,null,"Task 1"); var_Items.set_SelectItem(hChild,true); hChild = var_Items.InsertItem(h,null,"Task 2"); var_Items.set_CellState(hChild,0,1); hChild = var_Items.InsertItem(h,null,"Task 3"); var_Items.set_CellState(hChild,0,1); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1025 |
How can I change the caption of the checked items (sample 1)
axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1); var_Column.FormatColumn = "value + (%CS0 = 1 ? `<r><fgcolor=808080>(checked)` : ``)"; axGrid1.HeaderVisible = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Project"); int hChild = var_Items.InsertItem(h,null,"Task 1"); var_Items.set_SelectItem(hChild,true); hChild = var_Items.InsertItem(h,null,"Task 2"); var_Items.set_CellState(hChild,0,1); hChild = var_Items.InsertItem(h,null,"Task 3"); var_Items.set_CellState(hChild,0,1); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1024 |
How can I change the font for the checked items
// CellStateChanged event - Fired after cell's state has been changed. private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e) { axGrid1.Refresh(); } //this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.DefaultItemHeight = 22; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null); stdole.IFontDisp f = new stdole.StdFont() as stdole.IFontDisp; f.Name = axGrid1.Font.Name; f.Size = 12; var_ConditionalFormat.Font = (f as stdole.IFontDisp); axGrid1.HeaderVisible = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Project"); int hChild = var_Items.InsertItem(h,null,"Task 1"); var_Items.set_SelectItem(hChild,true); hChild = var_Items.InsertItem(h,null,"Task 2"); var_Items.set_CellState(hChild,0,1); hChild = var_Items.InsertItem(h,null,"Task 3"); var_Items.set_CellState(hChild,0,1); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1023 |
How can I bold the checked items
// CellStateChanged event - Fired after cell's state has been changed. private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e) { axGrid1.Refresh(); } //this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null); var_ConditionalFormat.Bold = true; axGrid1.HeaderVisible = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Project"); int hChild = var_Items.InsertItem(h,null,"Task 1"); var_Items.set_SelectItem(hChild,true); hChild = var_Items.InsertItem(h,null,"Task 2"); var_Items.set_CellState(hChild,0,1); hChild = var_Items.InsertItem(h,null,"Task 3"); var_Items.set_CellState(hChild,0,1); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1022 |
How can I change the foreground color for checked items
// CellStateChanged event - Fired after cell's state has been changed. private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e) { axGrid1.Refresh(); } //this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null); var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128)); axGrid1.HeaderVisible = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Project"); int hChild = var_Items.InsertItem(h,null,"Task 1"); var_Items.set_SelectItem(hChild,true); hChild = var_Items.InsertItem(h,null,"Task 2"); var_Items.set_CellState(hChild,0,1); hChild = var_Items.InsertItem(h,null,"Task 3"); var_Items.set_CellState(hChild,0,1); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1021 |
How can I change the background color for checked items (solid color)
// CellStateChanged event - Fired after cell's state has been changed. private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e) { axGrid1.Refresh(); } //this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null); var_ConditionalFormat.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128)); axGrid1.HeaderVisible = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Project"); int hChild = var_Items.InsertItem(h,null,"Task 1"); var_Items.set_SelectItem(hChild,true); hChild = var_Items.InsertItem(h,null,"Task 2"); var_Items.set_CellState(hChild,0,1); hChild = var_Items.InsertItem(h,null,"Task 3"); var_Items.set_CellState(hChild,0,1); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1020 |
How can I export the cell's state as well
axGrid1.BeginUpdate(); EXGRIDLib.Columns var_Columns = axGrid1.Columns; (var_Columns.Add("C1") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); (var_Columns.Add("C2") as EXGRIDLib.Column).FormatColumn = "1 index `A-Z`"; (var_Columns.Add("C3") as EXGRIDLib.Column).FormatColumn = "100 index ``"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item 1"); var_Items.set_CellState(var_Items.AddItem("Item 2"),null,1); var_Items.set_CellState(var_Items.AddItem("Item 3"),null,1); axGrid1.EndUpdate(); System.Diagnostics.Debug.Print( "Export CSV Items including Check-State:" ); axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column); var_Column.Position = 0; var_Column.FormatColumn = "%CS0"; System.Diagnostics.Debug.Print( axGrid1.Export("",null).ToString() ); axGrid1.Columns.Remove("Check"); axGrid1.EndUpdate(); |
1019 |
Is it possible to customize the editor selection colour of the built in text editor, from standard blue to black
axGrid1.BeginUpdate(); axGrid1.SelBackColor = Color.FromArgb(0,0,0); axGrid1.SelForeColor = Color.FromArgb(255,255,255); EXGRIDLib.Editor var_Editor = (axGrid1.Columns.Add("Edit") as EXGRIDLib.Column).Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.MaskType; var_Editor.Mask = ";;;rich"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(""); var_Items.AddItem("Just a text"); var_Items.AddItem(""); axGrid1.EndUpdate(); |
1018 |
Is it possible to customize the editor selection colour of the built in dropdown editor, from standard blue to black
axGrid1.BeginUpdate(); axGrid1.SelBackColor = Color.FromArgb(0,0,0); axGrid1.SelForeColor = Color.FromArgb(255,255,255); EXGRIDLib.Editor var_Editor = (axGrid1.Columns.Add("DropDown") as EXGRIDLib.Column).Editor; var_Editor.AddItem(1,"This is just the first item",null); var_Editor.AddItem(2,"This is just the second item",null); var_Editor.AddItem(3,"This is just the third item",null); var_Editor.EditType = EXGRIDLib.EditTypeEnum.DropDownType; var_Editor.Mask = ";;;rich"; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(""); var_Items.AddItem("Just a text"); var_Items.AddItem(""); axGrid1.EndUpdate(); |
1017 |
The BeforeExpandItem event is fired when clicking the drop down filter button. What we can do to prevent that
// BeforeExpandItem event - Fired before an item is about to be expanded (collapsed). private void axGrid1_BeforeExpandItem(object sender, AxEXGRIDLib._IGridEvents_BeforeExpandItemEvent e) { System.Diagnostics.Debug.Print( "BeforeExpandItem" ); System.Diagnostics.Debug.Print( e.item.ToString() ); System.Diagnostics.Debug.Print( "ColumnFromPoint" ); System.Diagnostics.Debug.Print( axGrid1.get_ColumnFromPoint(-1,-1).ToString() ); System.Diagnostics.Debug.Print( "ColumnFromPoint return -1, if the user clicks the +/- glitch, else it returns the index of the column where the click occurs." ); axGrid1.Items.InsertItem(e.item,null,"new child"); } //this.axGrid1.BeforeExpandItem += new AxEXGRIDLib._IGridEvents_BeforeExpandItemEventHandler(this.axGrid1_BeforeExpandItem); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Columns var_Columns = axGrid1.Columns; (var_Columns.Add("Items") as EXGRIDLib.Column).DisplayFilterButton = true; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_ItemHasChildren(var_Items.InsertItem(null,null,"Group 1"),true); var_Items.set_ItemHasChildren(var_Items.InsertItem(null,null,"Group 2"),true); axGrid1.EndUpdate(); |
1016 |
How do I change the drop down filter icon/button (black)
axGrid1.BeginUpdate(); EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQ" + "gmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYTh" + "dr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA"); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,-1); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,0x1000000); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exBackColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,1))); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exForeColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255))); axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarExclude,"<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>"); axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.None2; axGrid1.BackColorHeader = Color.FromArgb(0,0,0); axGrid1.ForeColorHeader = Color.FromArgb(255,255,255); axGrid1.HeaderVisible = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Filter") as EXGRIDLib.Column); var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowCheckBox; var_Column.DisplayFilterButton = true; var_Column.AllowSort = false; var_Column.AllowDragging = false; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("One"); var_Items.AddItem("Two"); var_Items.AddItem("Three"); axGrid1.EndUpdate(); |
1015 |
How do I change the drop down filter icon/button (white)
axGrid1.BeginUpdate(); EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN" + "J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" + "NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" + "hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" + "bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" + "BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI="); var_Appearance.Add(1,"CP:2 -4 -4 2 4"); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,0x1000000); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,axGrid1.BackColor); axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.None2; axGrid1.HeaderHeight = 24; axGrid1.BackColorHeader = Color.FromArgb(255,255,255); axGrid1.HeaderVisible = true; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Filter") as EXGRIDLib.Column); var_Column.DisplayFilterButton = true; var_Column.AllowSort = false; var_Column.AllowDragging = false; axGrid1.EndUpdate(); |
1014 |
How can I draw a solid frame around the the focusing item
axGrid1.BeginUpdate(); axGrid1.SingleSel = false; axGrid1.DefaultItemHeight = 20; EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.RenderType = -1; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABOkGACAADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBKUQSDqEYyjGLIXAWCYSAAMIwDKAUEwpFAZBhgeDYMiSNoYDJCM4wH" + "IURRJFCUJSGWQpTgSIgyT5HFIxXKoASbJabZLhWS6EpWOotTbIQQRYCkEyfKKfZyGURZQqOKA1DBZErWTJESRFJqLazgO4LAhyQYrVgAErzVKVCRNOqbJzADApdpGQJT" + "ULDNTQHRFIyhOSnIRrWbMAhid6JUZiVT4dBOIYhSYANAqCwLFqrDJmWrpV5WZjlZ47V6BdAyXJsIrmFJEXaOGhyDDlGybSDZYryfZhUziUw4XjbWwZDqPF6DKTTdSGLR" + "EE8WZVlURZvDaep3C+AY8kAYRgGCCBJECUhjDoHROEYWgoAGTQ1CEEx9lGMY0CQUYSnuZQDBGBYFlOH5+H+igGAKAJgEgFgGgGVgDn4CoCmCSA2A6A5hAgDgQgSYRIE4" + "EoFGGCBiBeBhhkgPgbgcYgICoH4IGGWIOCSBhiGiHgVgoYooFoAoLGIWI+DCCgjCiTgrgII4ImYOoOmOSJ2AYOpWlQDQBICA="); axGrid1.ShowFocusRect = true; axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exShowFocusRect,0x1000000); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("P1") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1013 |
The frame around the focusing item is not very clear. Can I show it larger or more cleared (sample 2)
axGrid1.BeginUpdate(); axGrid1.SingleSel = false; axGrid1.DefaultItemHeight = 20; axGrid1.ShowFocusRect = true; EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.RenderType = -1; var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABPEGACAADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBKUQSDqEYyjGLIXAWCYSAAMIwDKAUEwpFAZBhgeCRUgyJI3RgMUIzV" + "AcRRFEiUJQlIZZCjOAw0SIMU7xZRcNxsACnaZnCR4NiuRYiUhOcqzRIQIQ4CiEahqOgJbDUJYwWZKAyjBY8XTZFCSJCpeJ6egOc5jRxQUp1WAEXx3GSsJKvCZ5cADBY+" + "VLQNS0JBtMSTKSLaiuWoIJqCPaDRheWKQJh1NSnLqEcjyYANDxDCZlWzAYxWTZ2Uz7N7PbB0HY4DyPGKZYrfESVRbQcZNS6nNigPI9XhfGq6VjRe63ZaOaYpWrnOJqTR" + "WjOKYujWdZ2BGO5lkuBAAkmcQkDmDBEAwEQJCgGhMGcQ4pkiSxGAAOYmkQIhvkYNg2gSCgyj+LI4GIMIwF2XQoAYAoAmASAWAaAZgggJgKFiT54DYDoDmECBGBKBJgGg" + "TgWgWYRoFYGIGmGOBqByB5hCgegggiYJYgoJIICIaIeByChiigYgsgsYYYBYMIKCMKJOCuDRjGiOgLg6Y5InYPoPmQCAkmsXAQDQBCAg="); var_Appearance.Add(3,"CP:2 -3 0 3 0"); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exShowFocusRect,0x3010101); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("P1") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1012 |
The frame around the focusing item is not very clear. Can I show it larger or more cleared (sample 1)
axGrid1.BeginUpdate(); axGrid1.SingleSel = false; axGrid1.ShowFocusRect = true; EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABHoDg6AADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBIZQ7BKNIxjSJwFiCCQwSDKEjyCKcGRHF6MI6gOYpCgOIYjRJNIASV" + "AceAAGaUZrjSgobjmOYhAJCLqhYIgASXJqLaBlOCaAieSc+QhjQJIJoeCZXU5TFg1BTsOhqEqcRiseaRVDCaIJWzbdYWLDdNQHHKYLjnWorbpSJZ5XjNEySDQkMS9PrE" + "J7vST8FBCdAABLJUB2BR9RwxRafKpnWwJDpmCaOQLXEB5DK1PyVMTKYrtGy7GrIAJxWxbV4UHh+QABOzIMAvHKJMwvHYcUZne5XVLeF41HbONogPaJZyIAK2cLROq6Xo" + "7GEcJZEcLASB4DwvgWUZlE6AQQhKAYkkYdA6hyDIwHgSoqFwQgmnsYxjGgSIiBOTpSEiAwRgOJI7j4JAHA6U5wm0MpPlOBIjD8TZiGYCICiCGAuA6AxhAgMgSgOYQ4DY" + "Bg/g6cw1n+ABOmMMJ9DmCwjnScw4RsVJngkYh4hoKIKmKKI2CmC5ikiQgqgiT5jhyMw8g4QwIn0OIKEiCJhD8DwTGyfA7k0WQOEWEQkGkJhIhKZB5DYSoTiSCQEn4PQO" + "COXJcCeIJjliaIQk0aRyF4O5llmAhfhgZhJg4ZoYiaAxYn4PZOhOZJaCUZYTiYQw1mcOZUm+HQnHmWh4h6Z4pnYeYfk0eYsmqG4nAgNJ2DqD5DkCWoiGiOgqgyI5omoR" + "oNiSaQKFKEojCaM4ugSFhOjkAJcieKgDkaH4oioGoOiaKRqgqEoqDddwyhuAxPgOMJ8DyDZqk6NYtCsapmjiLprHqdo6i+K5K1oPhOlqPgKD4DpjnII4yiOewuk6MxtA" + "sMpSjObQ7EaT4wk6ewYn0PgPAiCJkjeLgDk6X44i4G4OmaORuguEpqDkLAzkaWg+E8GIUmaPIvEOVpzj2Lxbl6eo+G+S5in4OYPmOaJyjuTwjnYWpBg6DAjAqQZwkwJw" + "NkKcJsEcEJCDBEpaD6Dw8BiapGjGSgfB2RpxmyBwgkicZ8haBw/g+M5TBcPQPlOXJskscp8jsMJMnMLJXDGTZzEyYw2kwMoDlcFw9i2M4/EGUJPg0CxFlENBtCcSJSnQ" + "fQ0m+SgPHsaJ7lALZLG6XZVHWDRfFqVY1k0ZxdladYTnifJUGaeAWAeMnSGcGWgBObJ3lWbwdjKW5cHcTZPHaLkN4GxXDlFqFsA4uRbBOGAFAEIzAsDEFOBkfYqR4D6A" + "OBEYo8QuBvAmMceInBDgcD0JwOIqQyJ1DMAwG4IANDnHSMoK4QhOgMBGNEIQvQWAdGenETIswGiddsAAQAgCAgA=="); var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABeEGACAADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADDFIBQSLAYROGSDJBGODJDjWGIeQLOEhQH" + "IMRxPE6UYLhWYpBDKPYcUbGc7yBBMVwGf59XzACoKSheQIVSDQkw6Fo6NYhAxHALyNRkBy8f60KjtGpodDUJYvW5JYyjBZ8EznOqbJBkeJ7BgOe5NQjaD72VgdWQJFSW" + "JajWYYJDOJY2ZAAE5TVINEwxJbDaylChIdxaF6WAzZEBhBYoATPNLBMrhWqKDw2XaQWBCOgwHYeR5LU7BdRwbIrRq2eAAXbcVyXfDddZlBK+QA0SK9lRVTKvJZmKgBWw" + "1COSxmAAGw4kcNx1iKFBiCAfQsG8lJemucg7nsXpUHOOxrm+DI3jOH4XAOBx2nscw0j2HhPG4L5uGEVIECQCBCEUAYkGMHQHFGSBlGaAxkEgQgTGCVBsDYQhCgQJZrHK" + "UggGEShkFGNgIlsNpPnMHJHD+TADAIJIJiIWIeCqChikiIgmgiD5zHyXxgiACJKCuC4jHiZgtg6I4IlkCQwkwOIonMPJjEkFhGhGZBpA4KoMBCGJuEiE5lAkGg7hMY4J" + "EYVoUCUNAOE6FZl0KWQACWOR2GKF5mBmChchkJRZhoXYaCKKYqGuDglEmNhuhWZpIiYc4dCcCRqGmHZlgm2YxAwSQKESHwkFkKgpiAIAIH4PIimOOg2DiChoiQJRRD+T" + "ZDHCfwyAyCgyg+JpiioYJ/DgDgIlECQ6lwRAEICA="); var_Appearance.Add(3,"CP:2 -2 0 2 0"); (axGrid1.GetOcx() as EXGRIDLib.Grid).SelBackColor = 0x1000000; axGrid1.SelForeColor = Color.FromArgb(0,0,0); axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exShowFocusRect,0x3ff0000); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("P1") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1011 |
I have a column right-aligned. How can I display its check box aligned to the right, as it appears to the left of the cell's caption
axGrid1.BeginUpdate(); axGrid1.ColumnAutoResize = true; axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exVLines; EXGRIDLib.Columns var_Columns = axGrid1.Columns; EXGRIDLib.Column var_Column = (var_Columns.Add("Left") as EXGRIDLib.Column); var_Column.AllowSizing = false; var_Column.Width = 96; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.FormatColumn = "0 pos `A-Z`"; EXGRIDLib.Column var_Column1 = (var_Columns.Add("Center") as EXGRIDLib.Column); var_Column1.HeaderAlignment = EXGRIDLib.AlignmentEnum.CenterAlignment; var_Column1.Alignment = var_Column1.HeaderAlignment; var_Column1.AllowSizing = false; var_Column1.Width = 96; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column1.FormatColumn = "0 pos `A-Z`"; EXGRIDLib.Column var_Column2 = (var_Columns.Add("Right") as EXGRIDLib.Column); var_Column2.HeaderAlignment = EXGRIDLib.AlignmentEnum.RightAlignment; var_Column2.Alignment = var_Column2.HeaderAlignment; var_Column2.AllowSizing = false; var_Column2.Width = 96; var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.FormatColumn = "0 pos `A-Z`"; var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture"); var_Columns.Add(""); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1); var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1); var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1); axGrid1.EndUpdate(); |
1010 |
Can I display the column's multiple-lines caption vertically oriented (method 2)
axGrid1.BeginUpdate(); axGrid1.HeaderHeight = 48; axGrid1.ColumnAutoResize = true; EXGRIDLib.Columns var_Columns = axGrid1.Columns; var_Columns.Add("And others ..."); EXGRIDLib.Column var_Column = (var_Columns.Add("") as EXGRIDLib.Column); var_Column.HTMLCaption = "First Column"; var_Column.HeaderVertical = true; var_Column.Width = 36; var_Column.AllowSizing = false; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8); var_Column.Position = 0; EXGRIDLib.Column var_Column1 = (var_Columns.Add("") as EXGRIDLib.Column); var_Column1.HTMLCaption = "<c><b>Second Column"; var_Column1.HeaderVertical = true; var_Column1.Width = 36; var_Column1.AllowSizing = false; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8); var_Column1.Position = 1; EXGRIDLib.Column var_Column2 = (var_Columns.Add("") as EXGRIDLib.Column); var_Column2.HTMLCaption = "<r>Third Column"; var_Column2.HeaderVertical = true; var_Column2.Width = 36; var_Column2.AllowSizing = false; var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8); var_Column2.Position = 2; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1); var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1); var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1); axGrid1.EndUpdate(); |
1009 |
Can I display the column's multiple-lines caption vertically oriented (method 1)
axGrid1.BeginUpdate(); axGrid1.HeaderHeight = 48; axGrid1.HeaderSingleLine = false; axGrid1.ColumnAutoResize = true; EXGRIDLib.Columns var_Columns = axGrid1.Columns; var_Columns.Add("And others ..."); EXGRIDLib.Column var_Column = (var_Columns.Add("First Column") as EXGRIDLib.Column); var_Column.HeaderVertical = true; var_Column.Width = 36; var_Column.AllowSizing = false; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8); var_Column.Position = 0; EXGRIDLib.Column var_Column1 = (var_Columns.Add("Second Column") as EXGRIDLib.Column); var_Column1.HeaderBold = true; var_Column1.HeaderVertical = true; var_Column1.Width = 36; var_Column1.AllowSizing = false; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8); var_Column1.Position = 1; EXGRIDLib.Column var_Column2 = (var_Columns.Add("Third Column") as EXGRIDLib.Column); var_Column2.HeaderVertical = true; var_Column2.Width = 36; var_Column2.AllowSizing = false; var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8); var_Column2.Position = 2; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1); var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1); var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1); axGrid1.EndUpdate(); |
1008 |
Can I display the column's caption vertically oriented (method 2)
axGrid1.BeginUpdate(); axGrid1.HeaderHeight = 48; axGrid1.ColumnAutoResize = true; EXGRIDLib.Columns var_Columns = axGrid1.Columns; var_Columns.Add("And others ..."); EXGRIDLib.Column var_Column = (var_Columns.Add("") as EXGRIDLib.Column); var_Column.HTMLCaption = "First"; var_Column.HeaderVertical = true; var_Column.Width = 20; var_Column.AllowSizing = false; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.Position = 0; EXGRIDLib.Column var_Column1 = (var_Columns.Add("") as EXGRIDLib.Column); var_Column1.HTMLCaption = "<c><b>Second"; var_Column1.HeaderVertical = true; var_Column1.Width = 20; var_Column1.AllowSizing = false; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column1.Position = 1; EXGRIDLib.Column var_Column2 = (var_Columns.Add("") as EXGRIDLib.Column); var_Column2.HTMLCaption = "<r>Third"; var_Column2.HeaderVertical = true; var_Column2.Width = 20; var_Column2.AllowSizing = false; var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.Position = 2; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1); var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1); var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1); axGrid1.EndUpdate(); |
1007 |
Can I display the column's caption vertically oriented (method 1)
axGrid1.BeginUpdate(); axGrid1.HeaderHeight = 48; axGrid1.ColumnAutoResize = true; EXGRIDLib.Columns var_Columns = axGrid1.Columns; var_Columns.Add("And others ..."); EXGRIDLib.Column var_Column = (var_Columns.Add("First") as EXGRIDLib.Column); var_Column.HeaderVertical = true; var_Column.Width = 20; var_Column.AllowSizing = false; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.Position = 0; EXGRIDLib.Column var_Column1 = (var_Columns.Add("Second") as EXGRIDLib.Column); var_Column1.HeaderBold = true; var_Column1.HeaderVertical = true; var_Column1.Width = 20; var_Column1.AllowSizing = false; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column1.Position = 1; EXGRIDLib.Column var_Column2 = (var_Columns.Add("Third") as EXGRIDLib.Column); var_Column2.HeaderVertical = true; var_Column2.Width = 20; var_Column2.AllowSizing = false; var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.Position = 2; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1); var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1); var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1); axGrid1.EndUpdate(); |
1006 |
How do I automatically bold items being checked
// CellStateChanged event - Fired after cell's state has been changed. private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e) { } //this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged); axGrid1.BeginUpdate(); axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent; EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0","check"); var_ConditionalFormat.Bold = true; (axGrid1.Columns.Add("Items") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); (axGrid1.Columns.Add(axGrid1.ConditionalFormats["check"].Expression) as EXGRIDLib.Column).FormatColumn = axGrid1.ConditionalFormats["check"].Expression; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Item 1"); var_Items.set_CellState(var_Items.AddItem("Item 2"),0,1); var_Items.AddItem("Item 3"); axGrid1.EndUpdate(); |
1005 |
How can I use the CellState with ConditionalFormat/ComputedField/FormatColumn
// CellStateChanged event - Fired after cell's state has been changed. private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e) { } //this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged); axGrid1.BeginUpdate(); axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesInsideLeaf; axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent; EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Items") as EXGRIDLib.Column); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Format") as EXGRIDLib.Column); var_Column1.FormatColumn = "%CS0"; var_Column1.Caption = var_Column1.FormatColumn; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor)); EXGRIDLib.Items var_Items = axGrid1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Item 1"); var_Items.set_CellState(var_Items.InsertItem(h,null,"Item 2"),0,1); var_Items.set_CellState(var_Items.InsertItem(h,null,"Item 3"),0,1); var_Items.set_ExpandItem(h,true); axGrid1.EndUpdate(); |
1004 |
How can I use the CellData with ConditionalFormat/ComputedField/FormatColumn
axGrid1.BeginUpdate(); axGrid1.Columns.Add("Items"); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Format") as EXGRIDLib.Column); var_Column.FormatColumn = "%CD0"; var_Column.Caption = var_Column.FormatColumn; var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504); var_Column.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor)); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.set_CellData(var_Items.AddItem("Item 1"),0,1234); var_Items.set_CellData(var_Items.AddItem("Item 2"),0,"this is just an user data"); var_Items.set_CellData(var_Items.AddItem("Item 3"),0,Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); axGrid1.EndUpdate(); |
1003 |
How can I use the CellValue/CellCaption with ConditionalFormat/ComputedField/FormatColumn
axGrid1.BeginUpdate(); EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Items") as EXGRIDLib.Column); EXGRIDLib.Editor var_Editor = var_Column.Editor; var_Editor.EditType = EXGRIDLib.EditTypeEnum.DropDownListType; var_Editor.AddItem(1,"Item 1",null); var_Editor.AddItem(2,"Item 2",null); var_Editor.AddItem(3,"Item 3",null); EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Format") as EXGRIDLib.Column); var_Column1.FormatColumn = "%0"; var_Column1.Caption = var_Column1.FormatColumn; var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504); var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor)); var_Column1.AllowSizing = false; EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Format") as EXGRIDLib.Column); var_Column2.FormatColumn = "%C0"; var_Column2.Caption = var_Column2.FormatColumn; var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504); var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column2.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor)); var_Column2.AllowSizing = false; EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem(1); var_Items.set_CellValue(var_Items.AddItem(0),0,2); var_Items.AddItem(2); axGrid1.EndUpdate(); |
1002 |
Can I display the radio-button with a solid color
axGrid1.BeginUpdate(); axGrid1.set_RadioImage(false,32699122); axGrid1.set_RadioImage(true,16777216); (axGrid1.Columns.Add("Check") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellHasRadioButton,true); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Radio 1"); var_Items.set_CellState(var_Items.AddItem("Radio 2"),0,1); var_Items.AddItem("Radio 1"); axGrid1.EndUpdate(); |
1001 |
Can I display the check-box with a solid color
axGrid1.BeginUpdate(); axGrid1.set_CheckImage(EXGRIDLib.CheckStateEnum.Unchecked,32699122); axGrid1.set_CheckImage(EXGRIDLib.CheckStateEnum.Checked,16777216); (axGrid1.Columns.Add("Check") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true); EXGRIDLib.Items var_Items = axGrid1.Items; var_Items.AddItem("Check 1"); var_Items.set_CellState(var_Items.AddItem("Check 2"),0,1); var_Items.AddItem("Check 3"); axGrid1.EndUpdate(); |